In fact, if we go look at the benchmark code, we will see that the table is created, populated, and used, but statistics are never updated.
事实上,如果我们看一下基准代码,我们就会发现,该表已被创建、填充、并使用,但是统计信息没有被更新。
Note that Benchmark by default executes the task several times in order to gather statistics, and these multiple executions have the nice side effect of eliminating OSR as a performance issue.
注意,Benchmark在默认情况下会多次执行任务来收集统计数据,多次执行的副作用是消除OSR对性能的影响。
In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.
在我们对基准的第一个改进中,我们向账单表增加索引,并为表更新统计信息。
应用推荐